package com.lxf.education.dao;


import com.lxf.education.pojo.StudentPojo;
import com.lxf.education.pojo.TeacherPojo;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * Created by Luoxingfa on 2022/5/2 0002 19:46
 */
@Mapper
public interface StudentListMapper {

	
	//学生登录操作
	List<TeacherPojo> findStu(@Param("username")String username, @Param("password")String password);
	
    //查询所有数据
    List<StudentPojo> getAll();

    //分页查询
    List<StudentPojo> getAllStudent(@Param("start")Integer start, @Param("limit")Integer limit);

    //查询总条数
    int finCount();

    //通过姓名查询该用户的信息
	StudentPojo findStuByname(String name);

	//根据id查询学生信息
	StudentPojo findStuById(Integer id);

	//通过id更新数据
	void updateStu(StudentPojo student);

	//根据id删除
	void delStuById(Integer id);

	//批量删除
	void delAllStu(Integer[] ids);

	
}
